UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiUmdZQg1TA9Exdk9rlyky9QNgYSvXhkhzUM8cIecyw='
WHERE
key_id = 'f95b001eb313540527bf668e7d90816787763c39a1551637e287ec9487f5a3ae'
AND (
token = 'hiUmdZQg1TA9Exdk9rlyky9QNgYSvXhkhzUM8cIecyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)