UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVrcDz+il8hmCqv5Nu0waerJvo5WYtiphrVe/8LRHxw='
WHERE
key_id = '3ffc0913e0fc8240658059c4823f43c9a0bfe62448fdfef05cb7d4042e2a7fea'
AND (
token = 'BVrcDz+il8hmCqv5Nu0waerJvo5WYtiphrVe/8LRHxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)