UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9xSEhaCWoAkJcaIA+Ij+6T5BP0LVIPFs13801XXeGw='
WHERE
key_id = '4dfdb4ba60cbd207502cf65f896147440a583762687d0a8e8244771e9be941ab'
AND (
token = 'z9xSEhaCWoAkJcaIA+Ij+6T5BP0LVIPFs13801XXeGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)