UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AhBFD741F7TNo1O8k8St4i64TIBdvlG7WKgmsYBaMnQ='
WHERE
key_id = '3e406d9d3f8ebfb3196587c886d5a13572f6f164880556765c8dd00160b2f50c'
AND (
token = 'AhBFD741F7TNo1O8k8St4i64TIBdvlG7WKgmsYBaMnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)