UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ydi6Yi5yZ17yWiun9X8atSpf6CK+CEWoKc1miqdrJG4='
WHERE
key_id = 'd3cba8bef24c7e09c9c5927b2177180e72f872606d16d7ba7fd1a642909bd3a7'
AND (
token = 'Ydi6Yi5yZ17yWiun9X8atSpf6CK+CEWoKc1miqdrJG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)