UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yLUK8vitbZlR1wGFMGAbWtnG48QDSW3JWAjdkDKonCA='
WHERE
key_id = 'aecfb03f521774f3156c0c69f5d35472acac1167983a2fc7a63b4a6e1961e36b'
AND (
token = 'yLUK8vitbZlR1wGFMGAbWtnG48QDSW3JWAjdkDKonCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)