UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OsFnVo+PM3lWEEvwnKX2+xctRrOk657KYwnQQu3Qf+w='
WHERE
key_id = 'e95d4c8fdc90fb70404cb77e107688fb503818d930d8e5a9179ebef5421b3cbc'
AND (
token = 'OsFnVo+PM3lWEEvwnKX2+xctRrOk657KYwnQQu3Qf+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)