UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tIT3MewPSjpop4gJMLMW741jtModJA8hnvFp7r+kBWk='
WHERE
key_id = 'b59848da511d17c247ba639d4b52055e8c5eb77361ae8f1e97a412e9b7f20df4'
AND (
token = 'tIT3MewPSjpop4gJMLMW741jtModJA8hnvFp7r+kBWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)