UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iHZEoPPx7X4T+9d6U0gCUWXE0WMUTrAsidVOgIzWEVE='
WHERE
key_id = '1da579ec7648c5efec4c76a8a966e06cfd17b96b6d3e56f9e295436de6b14a7b'
AND (
token = 'iHZEoPPx7X4T+9d6U0gCUWXE0WMUTrAsidVOgIzWEVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)