UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q3pFQUDnHAj+jxR7OS+Wxu7aHoSoHVEvN6TKOIFpxhk='
WHERE
key_id = '49ec7ac20f3c0fb87ad8a94612fdceb36bcfc76960f6caecabd93e91d7d31e38'
AND (
token = 'Q3pFQUDnHAj+jxR7OS+Wxu7aHoSoHVEvN6TKOIFpxhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)