UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNrr/IBKdDMTr6YR8fWfntjTBC8kYy/edEbRYwYl7U0='
WHERE
key_id = '8f4ccb711599ed251d80bb39564bcddcb224a4dae4e017ab5d686a6f094a128c'
AND (
token = 'XNrr/IBKdDMTr6YR8fWfntjTBC8kYy/edEbRYwYl7U0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)