UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afO41EZgwrzvlmRdxV+0hoy1bM7aor2LvotmuGnE9r8='
WHERE
key_id = 'ab12c8396542da2ee8960e657f035f40e77a272b6aca5f8c6820f7f99ee49272'
AND (
token = 'afO41EZgwrzvlmRdxV+0hoy1bM7aor2LvotmuGnE9r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)