UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXz5wCFBgDi9mJBMdMxVSOTisVxYN9wfLo0OSvElIwA='
WHERE
key_id = '80237ec257859073d3b570fc74baccc50dcb53ea32244b9849da7cb15393d15a'
AND (
token = 'lXz5wCFBgDi9mJBMdMxVSOTisVxYN9wfLo0OSvElIwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)