UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/O1xjZR0ZNs0QyyQ6M2WUAVbchAQaAYbimFa4h8kj1I='
WHERE
key_id = 'a917a1a8bab79d28f31a362fe99b65fa62139efc155aeed1ad682f40aa323992'
AND (
token = '/O1xjZR0ZNs0QyyQ6M2WUAVbchAQaAYbimFa4h8kj1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)