UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h18PzjRUi0hyX9WJBjtI+yaVf7Is1l1h3Wx10aiIKWA='
WHERE
key_id = '3df71894a6f2d3d2abaf95984b13da3436f724f41c71c465a04f15663ee6f3bd'
AND (
token = 'h18PzjRUi0hyX9WJBjtI+yaVf7Is1l1h3Wx10aiIKWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)