UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwBtWe0O+7Reas2RnRQzry63igdhD91W1Z7jwhjyfLk='
WHERE
key_id = 'ca565a9248bc973d3246d2a8a3e02c0ca54ddf7891f1a874663bc2595b5cf9cb'
AND (
token = 'hwBtWe0O+7Reas2RnRQzry63igdhD91W1Z7jwhjyfLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)