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