UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fi5cKLo5O/2CJWC0bPEmplkbxVDaGmtLs1Xs97hWJxU='
WHERE
key_id = 'f92077ae1ae0dd4ed6bdecdf07d6eba5ae09774efb0c51debb92b7c65a1bdd1e'
AND (
token = 'fi5cKLo5O/2CJWC0bPEmplkbxVDaGmtLs1Xs97hWJxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)