UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfhI11PL8ftWPadBs+MOX6NUgFz9+2syvD9POHN2BbU='
WHERE
key_id = '5fe82c0f4d637c5dab3ada1378cfa8981e70ac894fe51ee823ad22e4ae6bde49'
AND (
token = 'xfhI11PL8ftWPadBs+MOX6NUgFz9+2syvD9POHN2BbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)