UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xLCRH8gVyNThXpayvdJ+yPh8WYCtfwMYHfk0xvOXgc='
WHERE
key_id = 'd280f7915e9f53cdd1cf6e81d17d725de7e8d8dc8239d93de075c11653cb0599'
AND (
token = '4xLCRH8gVyNThXpayvdJ+yPh8WYCtfwMYHfk0xvOXgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)