UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hY/TOhsuIQQs3ZamE7/YSZAAsqBbFl9SmxFpjNspqI='
WHERE
key_id = '9c91499a5d7deb67c1a9bc92da32d115a54d8c0849b908dcb0fa2d7a05a13202'
AND (
token = '1hY/TOhsuIQQs3ZamE7/YSZAAsqBbFl9SmxFpjNspqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)