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