UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fc176mbNCQshOCidGmcMDLl453ACOkb5Sk6+8f7tn6E='
WHERE
key_id = '8c34f8a77d58fc5e92923a90c2469fee94e3bfd4dbd96366f84f304cc1fc95de'
AND (
token = 'fc176mbNCQshOCidGmcMDLl453ACOkb5Sk6+8f7tn6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)