UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '33UbWA22CuhncN/p3avxwlmVyJJG7B4btqL+nck70+A='
WHERE
key_id = '647ae8e54bae4141675efc23de56c64c64771db0e6434bef6d2b06241aa79c84'
AND (
token = '33UbWA22CuhncN/p3avxwlmVyJJG7B4btqL+nck70+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)