UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gzSk9Nzo+98B8tbcThWMfJgVQL/yzJSjYzPspD2+cAs='
WHERE
key_id = '1ca96ac9a6263d5b78e807daf10e090eb0a5ac13a84522e51615fead6276f052'
AND (
token = 'gzSk9Nzo+98B8tbcThWMfJgVQL/yzJSjYzPspD2+cAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)