UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qkoTqJQg9PsXFqESt4Ho7iy9ZrVAkzqwjiL8m7NmCOU='
WHERE
key_id = 'a2123f5d2870d51a1d9fb22427fc734dc47f9ae70b43ac7ca1fffaae2b796d25'
AND (
token = 'qkoTqJQg9PsXFqESt4Ho7iy9ZrVAkzqwjiL8m7NmCOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)