UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZ1t1WvSfGvx6p2jXcyZxrxZv/YVVHUeRe+nxHverBo='
WHERE
key_id = 'ba81b88eaa6df663b6592243847c76ed3c974a081a36514794dbfd211651f0f3'
AND (
token = 'tZ1t1WvSfGvx6p2jXcyZxrxZv/YVVHUeRe+nxHverBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)