UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y4r+hJpb1QfwpNMzZKZid2PcuE6o2EozkryeM136qYs='
WHERE
key_id = 'ecd97cf4e1a869dc24c9c7e2bf9ba91ba11087dd8989b75028e999b89d2d457f'
AND (
token = 'y4r+hJpb1QfwpNMzZKZid2PcuE6o2EozkryeM136qYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)