UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aQlrV4RRBWKNOjhEuYT4tMhy2WIEXn4fwtTfioQEyMg='
WHERE
key_id = 'd499a07596c7c80a0d25a3872531ac10fb86983f633014099e4b35322038f7fd'
AND (
token = 'aQlrV4RRBWKNOjhEuYT4tMhy2WIEXn4fwtTfioQEyMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)