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