UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gi9D5rSdCXtmqQymqLrFAO2r2lUon6u6SVjDJpwEKTQ='
WHERE
key_id = '7d612a38d9e1915fbddba0dfd9dcf6e1e90c17938444dcfcef9c78443dc82fa2'
AND (
token = 'gi9D5rSdCXtmqQymqLrFAO2r2lUon6u6SVjDJpwEKTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)