UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qQeejNEYgsCW28ifc3q8eb/XS1yVFAuP2y4XiSktqbY='
WHERE
key_id = 'd76ddbf4f16238b44567e97f01360faa305d72582c7952a0cb67af4f287c20ea'
AND (
token = 'qQeejNEYgsCW28ifc3q8eb/XS1yVFAuP2y4XiSktqbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)