UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nL0L97PlUKlMo0s6J9vX0EC0Xdl8HW2LUeW98nqFyoc='
WHERE
key_id = '639f722c56f95e4c4ee1f720bda7733ce6d5ab263be92e75354ba27c0a8ecf1f'
AND (
token = 'nL0L97PlUKlMo0s6J9vX0EC0Xdl8HW2LUeW98nqFyoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)