UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8REJsom01UgRDHFAYb38X2G9n/B+OPUKxBuhilqmSc='
WHERE
key_id = 'b988aed860e86f3e741c4c995c826a04c6efe178680166e022e5a06dcf503127'
AND (
token = 'N8REJsom01UgRDHFAYb38X2G9n/B+OPUKxBuhilqmSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)