UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gH3vPBHKkH9KLWOZP3YZNCJdkCTsiTzkIj4zcBj/7pI='
WHERE
key_id = '2a9521bfec548df9e9b7cde3a1fa2b2edc4107e47936e791f2e2a49abc04b004'
AND (
token = 'gH3vPBHKkH9KLWOZP3YZNCJdkCTsiTzkIj4zcBj/7pI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)