UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0PfnImOxiYn5hJOoTwIlvw/7JaP74ja6DYDizZ6f9zA='
WHERE
key_id = '44750c3cc57d92f1916689f68fe6a30946bc8470d3e8513894b70744ecc4172c'
AND (
token = '0PfnImOxiYn5hJOoTwIlvw/7JaP74ja6DYDizZ6f9zA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)