UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8oOsQzFUvRDijztAe7JAflUOzNDPaMucABpkxJo27E='
WHERE
key_id = '101c7b1aa218078a0bc5595805d6bf917315e80fbc68fc39c3968cf5ca227c50'
AND (
token = 'u8oOsQzFUvRDijztAe7JAflUOzNDPaMucABpkxJo27E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)