UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7Z2tu7LWaQL3130HTtvWictpaAllYGjTpDM1R7wj3I='
WHERE
key_id = '57ffbf177ea766a06dc60d52c1e964eda1d8ff760fa624773f9e178b5c664baa'
AND (
token = 'L7Z2tu7LWaQL3130HTtvWictpaAllYGjTpDM1R7wj3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)