UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pBTzAhDfaRJOPJIFnlWi3Nm0J5QSj1VaXXhOALA2rE='
WHERE
key_id = '196dcf296dd56b937c8520ce38b64945ea0d38da744ba7cdc0a4c2bace08ba21'
AND (
token = '8pBTzAhDfaRJOPJIFnlWi3Nm0J5QSj1VaXXhOALA2rE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)