UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gcEOMu+hO6Q3fJWwskIQGIjMpZsC5woSWQaSBm4//o='
WHERE
key_id = 'd4b835aac4f497003b3ed493bd2dc17841e86f3fd3a695f4f1f48894181009e3'
AND (
token = '6gcEOMu+hO6Q3fJWwskIQGIjMpZsC5woSWQaSBm4//o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)