UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yqrX1Aoen79EvoQePUIaHFSdMlR3ZPCZ72XhXDSnmhU='
WHERE
key_id = 'e5824f391d03706b7a41313fd2e89c0decf80ab1edf29e098fb9bc67b06dcf29'
AND (
token = 'yqrX1Aoen79EvoQePUIaHFSdMlR3ZPCZ72XhXDSnmhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)