UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v0iEhjEaYvybdoc3mWToqorXcd4eZDSGnbRBpv/K6kk='
WHERE
key_id = 'a885c9fb098186da69bb9596ecc1d78420a40ad5401b2095d153f00a8effbb48'
AND (
token = 'v0iEhjEaYvybdoc3mWToqorXcd4eZDSGnbRBpv/K6kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)