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