UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYiWYYa8wu7kSznbure9xLXjdwxhpn3O4/qvdapqVeM='
WHERE
key_id = 'b604ed1d29497b1229477c2735306bd7bb19eb697b99a89a7a2f20f24ef8212f'
AND (
token = 'XYiWYYa8wu7kSznbure9xLXjdwxhpn3O4/qvdapqVeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)