UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C5Esa4AACCcfnYT3mb4AKmrl4o2Na9InT4gsESzaNqU='
WHERE
key_id = '2e74057f02c395d87a7a1b30542d7b2db3a6b709ac43fb381cf0f47300cc5118'
AND (
token = 'C5Esa4AACCcfnYT3mb4AKmrl4o2Na9InT4gsESzaNqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)