UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dG5G65QJoly9cWLm3HNJnSFRrfoksuk7AAaeZbV3SKo='
WHERE
key_id = '120ecedab63675386d2ec50fadbe057969e6776c978fc02c69a33aa489389a25'
AND (
token = 'dG5G65QJoly9cWLm3HNJnSFRrfoksuk7AAaeZbV3SKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)