UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J38w11gHJyjsmOkAvjXmCjkv3HrAiuzQFbUznFmc2Io='
WHERE
key_id = '6bb5af9ac2293286e222755f7f660d0bd6b0258326989e0065b09d2e3a63acaa'
AND (
token = 'J38w11gHJyjsmOkAvjXmCjkv3HrAiuzQFbUznFmc2Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)